Elasticsearch解决Result window is too large, from + size must be less than or equal to: [10000] but was [10025]问题

问题描述

在使用Elasticsearch做分页查询时，当查询记录超过10000时，会报如下错误

Result window is too large, from + size must be less than or equal to: [10000] but was [10025]. See the scroll api for a more efficient way to request large data sets. This limit can be set by changing the [index.max_result_window] index level parameter.

查阅文档可知，默认只能查询到10000

1
2

index.max_result_window
The maximum value of from + size for searches to this index. Defaults to 10000. Search requests take heap memory and time proportional to from + size and this limits that memory. See Scroll or Search After for a more efficient alternative to raising this.

解决办法

修改索引index的max_result_window属性，设置最大返回结果的大小

put http://10.127.0.1:9200/test/_settings
{
    "index.max_result_window":1000001
}

修改成功后返回

1
2
3

{
    "acknowledged": true
}